<?

//ini_set('display_errors',1);

require "inc/funkce.php";
require "inc/conf.php";
require "adm2/req/pass.php";

$conf_img_path_arr[5] = 'http://old.zapoklady.cz/'; // $root / http://www.zapoklady.cz/
$root_zp = 'http://old.zapoklady.cz/';
$vkcb_link = 'http://www.klasterbroumov.cz/';

/*
get page & seo params by send url

get url & page ID & META:
1) check lang by /en/ ...
2) search last part of url in db: "url" table [url,table,id,lang]
3) set page ID,table name & meta
4) add other languages url of cur. page to lang links
*/

// conf types
$send_url = $_SERVER['REQUEST_URI'];

// def. get params
$get_m = false;

// check if url contain params (?)
$send_parms = $sql_main_get = false;
$pos = strpos($send_url, '?');
if ($pos !== false) {
	$tmp_arr = explode('?',$send_url);
	$send_url = trim($tmp_arr[0]);
	
	// handle params
	$send_parms = trim($tmp_arr[1]);
	$params_arr = explode('&',$send_parms);
	
	// main catogories
	foreach ($params_arr as $key => $value_get) {
		$value_get = urldecode($value_get);
		$tmp_value_arr = explode('=',$value_get);
		$value = $tmp_value_arr[1];
		$key = $tmp_value_arr[0];
		
		if ($value!='') {
			// send month
			if ($key=='m') {
        		$get_m = FixInt($value); // def->'cs'
			}
		}
	}
}

// conf types
if (substr($send_url,-1)=='/') $send_url = substr($send_url,0,-1);
$page_arr = explode('/',$send_url);
$url_pos = $page_arr[count($page_arr)-1]!='' ? 1 : 2; // detect '/' at last char
$page_link = $page_arr[count($page_arr)-$url_pos]; // detect page key
$page_lang = $page_arr[count($page_arr)-($url_pos+1)]; // detect page key
$page_id = $page_type = $page = $poi_id = $table = $title = $descr = $title_seo = $descr_seo = $page_top = $types_id = $category_main_id = $aktuality_id = $breadcrumb = $logo_title = $logo_date = $datum = false;
$page_url_arr = $types_arr = $types_url_arr = $types_top_arr = $category_arr = $category_url_arr = $category_top_arr = $pages_arr = $pages_url_arr = $pages_top_arr = $pages_pcs_arr = $pages_text_arr = $data_url_arr = $menu_title_arr = $menu_url_arr = $high_category_arr = $data_typzobrazeni_arr = $poi_arr = $poi_url_arr = array();

// pages
$page_o_festivalu = 208;
$page_program = 209;
$page_archiv = 11;
$page_mista = 210;
$page_fotogalerie = 211;
$page_kontakty = 212;
$page_kurzy = 213;
$page_partneri = 10;
$page_logo = 214;
$page_news = 219;
$page_press = 222;

$hledani = isset($_POST['hl']) && $_POST['hl'] ? $_POST['hl'] : false;

// detect language
if ($page_link=='en' || $page_lang=='en') {
	$lang_sql_str = '1';
	$lang = 'en';
	$language_link = 'en/';
	
	include "inc/lang-en.php";
} else if ($page_link=='de' || $page_lang=='de') {
	$lang_sql_str = '3';
	$lang = 'de';
	$language_link = 'de/';
	
	include "inc/lang-de.php";
} else if ($page_link=='pl' || $page_lang=='pl') {
	$lang_sql_str = '2';
	$lang = 'pl';
	$language_link = 'pl/';
	
	include "inc/lang-pl.php";
} else {
	$lang_sql_str = '';
	$lang = 'cs';
	$language_link = 'cs/';
	
	include "inc/lang-cs.php";
}

// list all program
$program_arr = $program_url_arr = $program_date_arr = $program_week_arr = $program_year_arr = $program_pcs_arr = $program_key_arr = $program_idpoi_arr = $program_day_arr = $program_time_arr = $program_title_arr = array();
$sSql = "SELECT * FROM aktuality WHERE status>'0' AND zapoklady IS TRUE AND typ='10' ORDER BY datum DESC"; // DOCASNE!!! AND status>'0' AND zapoklady IS TRUE AND typ='10'  WHERE (id=1493 OR (id>=1496 AND id<=1505))
$vysledek = Pg_Exec($sSql);
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
	$program_key_arr[] = $zaznam['id'];
	$program_idpoi_arr[$zaznam['id']] = $zaznam['idpoi'];
	
	// convert str to tag array
	$chars = preg_split('/<[^>]*[^strong\/]>/i', printSqlCol('popis'.$lang_sql_str,$zaznam), -1, PREG_SPLIT_NO_EMPTY | PREG_SPLIT_DELIM_CAPTURE);
	
	// find STRONG paragraph
	$str = false;
	foreach ($chars as $key => $value) {
		if (strpos($value, '<strong') !== false && !$str) {
			$str = $value;
		}
	}
	
	$program_arr[$zaznam['id']] = $str;
	$program_title_arr[$zaznam['id']] = printSqlCol('titulek'.$lang_sql_str,$zaznam);
	$program_url_arr[$zaznam['id']] = $root.$language_link.printSqlCol('link'.$lang_sql_str,$zaznam);
	$program_www_arr[$zaznam['id']] = printSqlCol('www'.$lang_sql_str,$zaznam);
	$program_date_arr[$zaznam['id']] = GetCzDateShortFree(printSqlCol('datum',$zaznam));
	$program_dateRegular_arr[$zaznam['id']] = strtotime(printSqlCol('datum',$zaznam));
	$program_week_arr[$zaznam['id']] = date('W',strtotime(printSqlCol('datum',$zaznam)));
	$program_year_arr[$zaznam['id']] = date('Y',strtotime(printSqlCol('datum',$zaznam)));
	$program_day_arr[$zaznam['id']] = $conf_day_arr[date('N',strtotime(printSqlCol('datum',$zaznam)))];
	$program_time_arr[$zaznam['id']]  = printSqlCol('cas',$zaznam) ? ' '.$od_text.' '.GetCzTime(printSqlCol('cas',$zaznam)) : ''; //', '.
	$program_pcs_arr[$zaznam['id']] = printSqlCol('imgpath',$zaznam)>0 ? $conf_img_path_arr[printSqlCol('imgpath',$zaznam)].'galerie/aktuality/'.$zaznam['id'].'/'.printSqlCol('soubor',$zaznam) : ''; // $root.'galerie/aktuality/'.$zaznam['id'].'/'.printSqlCol('soubor',$zaznam);
}

// pois
$pois_arr = $pois_text_arr = $pois_url_arr = $pois_lat_arr = $pois_lon_arr = $pois_zoom_arr = $pois_soubor_arr = array();
$poi_sql = implode(' OR id=',$program_idpoi_arr);
$sSql = "SELECT * FROM poi WHERE status>'0' AND (id=$poi_sql) ORDER BY razeni"; // DOCASNE!!! AND zapoklady IS TRUE AND typ='10'
$vysledek = Pg_Exec($sSql);
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
	$pois_arr[$zaznam['id']] = printSqlCol('titulek'.$lang_sql_str,$zaznam);
	$pois_text_arr[$zaznam['id']] = printSqlCol('popis'.$lang_sql_str,$zaznam);
	$pois_url_arr[$zaznam['id']] = $root.$language_link.printSqlCol('link'.$lang_sql_str,$zaznam);
	$pois_lat_arr[$zaznam['id']] = printSqlCol('lat',$zaznam);
	$pois_lon_arr[$zaznam['id']] = printSqlCol('lon',$zaznam);
	$pois_zoom_arr[$zaznam['id']] = printSqlCol('zoom',$zaznam);
	$pois_soubor_arr[$zaznam['id']] = printSqlCol('soubor',$zaznam) ? $conf_img_path_arr[printSqlCol('imgpath',$zaznam)].'galerie/poi/'.$zaznam['id'].'/m-'.printSqlCol('soubor',$zaznam) : '';
}

// main catogories
if ($page_link == 'zapoklady.cz' || $page_link == 'index.php' || in_array($page_link,$conf_web_domains) || $page_link == '' || $page_link=='cs' || $page_link=='en' || $page_link=='pl') {
	$page = 'homepage';
	$page_url_arr = array('cs'=>'http://old.zapoklady.cz/','en'=>'http://old.zapoklady.cz/en/','pl'=>'http://old.zapoklady.cz/pl/');
	
	$table = 'zapoklady';
	$homepage_id = $page_id = 214;
	
	// homepage content
	$homepage_title_arr = $homepage_text_arr = array();
	$i = 0;
	
	// for all pages read products pages for top menu (cache?)
	$sSql = "SELECT * FROM zapoklady WHERE status='1' ORDER BY razeni";
	$vysledek = Pg_Exec($sSql);
	while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
		
		// if not set page icon use page title
		$ikona_tmp = printSqlCol('ikona'.$lang_sql_str,$zaznam);
		$pages_arr[$zaznam['id']] = $ikona_tmp!='' ? $ikona_tmp : printSqlCol('titulek'.$lang_sql_str,$zaznam);
		$pages_url_arr[$zaznam['id']] = $root.$language_link.printSqlCol('link'.$lang_sql_str,$zaznam);
		
		// if set, add link to this page as subpage
		$pages_top_arr[$zaznam['id']] = printSqlCol('idhlavnistranky',$zaznam);
		
		// if this page == current -> set page type
		if ($zaznam['id']==$homepage_id) {
			$page_type = printSqlCol('idtypustranky',$zaznam);
			$page_top = printSqlCol('idhlavnistranky',$zaznam);
			
			if (!$title) $title = printSqlCol('titulek'.$lang_sql_str,$zaznam);
			$perex = printSqlCol('perex'.$lang_sql_str,$zaznam);
			$text = printSqlCol('popis'.$lang_sql_str,$zaznam);
		}
		
		if ($zaznam['idhlavnistranky']==$homepage_id) {
			$i++;
			$homepage_title_arr[$i] = printSqlCol('titulek'.$lang_sql_str,$zaznam);
			$homepage_text_arr[$i] = printSqlCol('popis'.$lang_sql_str,$zaznam);
		}
		
		// add all POI pages to arr
		if (isset($zaznam['idpoi']) && $zaznam['idpoi']>0) {
			$poi_arr[] = printSqlCol('titulek'.$lang_sql_str,$zaznam);
			$poi_url_arr[] = printSqlCol('link'.$lang_sql_str,$zaznam);
		}
		
		// set logo texts
		if ($zaznam['id']==$page_logo) {
			$logo_title = printSqlCol('titulek'.$lang_sql_str,$zaznam);
			$logo_date = nl2br(printSqlCol('perex'.$lang_sql_str,$zaznam));
		}
	}
	
} else {
	// found url in db
	$sSql = "SELECT * FROM url WHERE url$lang_sql_str='$page_link'";
	$vysledek = Pg_Exec($sSql);
	while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
		
		// page conf
		$page = printSqlCol('url'.$lang_sql_str,$zaznam);
		$page_id = printSqlCol('idzaznamu',$zaznam);
		$table = printSqlCol('tabulka',$zaznam);
		
		// links to other langs
		$page_url_arr = array('cs'=>$root.'cs/'.printSqlCol('url',$zaznam),'en'=>$root.'en/'.printSqlCol('url1',$zaznam),'pl'=>$root.'pl/'.printSqlCol('url2',$zaznam));
		
		// seo for cur. page in cur. lang
		$title_seo = printSqlCol('title'.$lang_sql_str,$zaznam);
		$descr_seo = printSqlCol('descr'.$lang_sql_str,$zaznam);
	}
	
	// for all pages read products pages for top menu (cache?)
	$sSql = "SELECT * FROM zapoklady WHERE status='1' ORDER BY razeni";
	$vysledek = Pg_Exec($sSql);
	while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
		
		// if not set page icon use page title
		$ikona_tmp = printSqlCol('ikona'.$lang_sql_str,$zaznam);
		$pages_arr[$zaznam['id']] = $ikona_tmp!='' ? $ikona_tmp : printSqlCol('titulek'.$lang_sql_str,$zaznam);
		$pages_url_arr[$zaznam['id']] = printSqlCol('link'.$lang_sql_str,$zaznam);
		$pages_pcs_arr[$zaznam['id']] = printSqlCol('soubor',$zaznam);
		$pages_text_arr[$zaznam['id']] = strip_tags(printSqlCol('popis'.$lang_sql_str,$zaznam));
		
		// if set, add link to this page as subpage
		$pages_top_arr[$zaznam['id']] = printSqlCol('idhlavnistranky',$zaznam);
		
		// if this page == current -> set page type
		if ($page_id>0 && $zaznam['id']==$page_id && $table=='zapoklady') {
			$page_type = printSqlCol('idtypustranky',$zaznam);
			$page_top = printSqlCol('idhlavnistranky',$zaznam);
			
			if (!$title) $title = printSqlCol('titulek'.$lang_sql_str,$zaznam);
			$perex = printSqlCol('perex'.$lang_sql_str,$zaznam);
			$text = printSqlCol('popis'.$lang_sql_str,$zaznam);
		}
		
		// set logo texts
		if ($zaznam['id']==$page_logo) {
			$logo_title = printSqlCol('titulek'.$lang_sql_str,$zaznam);
			$logo_date = nl2br(printSqlCol('perex'.$lang_sql_str,$zaznam));
		}
	}
	
	// breadcrumb
	
	// 1st level
	$breadcrumb = '';
	
	// 2nd level
	if (isset($pages_top_arr[$page_id]) && $pages_top_arr[$page_id]>0) {
		$breadcrumb = '<a href="'.$root.$language_link.$pages_url_arr[$pages_top_arr[$page_id]].'">'.$pages_arr[$pages_top_arr[$page_id]].'</a> / <span>'.$breadcrumb.'</span>';
		
		// 3rd level
		if (isset($pages_top_arr[$pages_top_arr[$page_id]])) {
			$tmp_top = $pages_top_arr[$pages_top_arr[$page_id]];
			if (isset($pages_arr[$tmp_top]) && $pages_arr[$tmp_top]!='') $breadcrumb = '<a href="'.$root.$language_link.$pages_url_arr[$tmp_top].'">'.$pages_arr[$tmp_top].'</a> / '.$breadcrumb;
			
			// 4th level
			if (isset($pages_top_arr[$tmp_top])) {
				$tmp_top = $pages_top_arr[$tmp_top];
				if (isset($pages_arr[$tmp_top]) && $pages_arr[$tmp_top]!='') $breadcrumb = '<a href="'.$root.$language_link.$pages_url_arr[$tmp_top].'">'.$pages_arr[$tmp_top].'</a> / '.$breadcrumb;
			}
		}
	}
	
	// get SEO & page data
	if ($page_id>0 && $table!='') {
		
		// read from db only if page not category or clasic page...ex.: "realizace", "produkty"...
		if ($table!='zapoklady') {
			$vysledek = Pg_Exec("SELECT * FROM $table WHERE id = '$page_id'"); // AND status>0
			if ($vysledek) {
				$zaznam = @Pg_Fetch_Array($vysledek,0);
			
				if (!$title) $title = printSqlCol('titulek'.$lang_sql_str,$zaznam);
				$perex = printSqlCol('perex'.$lang_sql_str,$zaznam);
				$text = printSqlCol('popis'.$lang_sql_str,$zaznam);
				if (printSqlCol('datum',$zaznam)!='') $datum = GetCzDateShortFree(printSqlCol('datum',$zaznam));
			}
		}
	}
}

// set lat & lon vars
$lat = $lon = false;
if ($table=='poi') {
	$lat = $pois_lat_arr[$page_id];
	$lon = $pois_lon_arr[$page_id];
	
} else if ($table=='aktuality' && isset($program_idpoi_arr[$page_id])) {
	$poi_tmp = $program_idpoi_arr[$page_id];
	$lat = $pois_lat_arr[$poi_tmp];
	$lon = $pois_lon_arr[$poi_tmp];
}

// 404 error page
if (!$page) {
	$page = '404';
}
?>
<!DOCTYPE html>
<html>

<head>
    <title><? echo $title_seo ? $title_seo : $conf_title.' - '.$title ?></title>
    <meta charset="UTF-8">
    <meta name="description" content="<? echo $descr_seo ? $descr_seo : $conf_descr.' - '.$title ?>" />
    <meta name="viewport" content="width=device-width, minimum-scale=1.0, maximum-scale=1.0">
    <link rel="stylesheet" type="text/css" href="<? echo $root ?>css/style.css">
    <link rel="stylesheet" href="<? echo $root ?>fancybox/source/jquery.fancybox.css?v=2.1.5" type="text/css" media="screen">
    <script type="text/javascript" src="<? echo $root ?>js/jquery-1.10.2.min.js"></script>
    <script type="text/javascript" src="<? echo $root ?>fancybox/source/jquery.fancybox.pack.js?v=2.1.5"></script>
    <script type="text/javascript" src="<? echo $root ?>js/jquery.matchHeight.js"></script>
    <script type="text/javascript" src="<? echo $root ?>js/jquery.call.js"></script>
    <script type="text/javascript" src="<? echo $root ?>js/custom.js"></script>
<? if ($lat && $lon) {
	$map = true;
?>
    <script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyCo-qpUO388j_oeVBFonbBvzMRDskNDHYE&sensor=false"></script>
    <script type="text/javascript" src="<? echo $root ?>js/map.php?lat=<? echo $lat ?>&amp;lon=<? echo $lon ?>"></script>
<? } ?>
</head>

<header>
    <div class="header-box">
        <a href="<? echo $root ?>" id="logo">
            <img src="<? echo $root ?>images/logo-top.png" alt="">
        </a>
        <nav>
            <div class="menu">
                <div>
                    <a href="<? echo $pages_url_arr[$page_o_festivalu] ?>"><? echo $pages_arr[$page_o_festivalu] ?></a>
<? if (in_array($page_o_festivalu,$pages_top_arr)) { ?>
                    <ul>
<? foreach ($pages_top_arr as $key => $value) {
	if ($value==$page_o_festivalu) {
?>
                        <li><a href="<? echo $pages_url_arr[$key] ?>"><? echo $pages_arr[$key] ?></a></li>
<? }
} ?>
                    </ul>
<? } ?>
                </div>
                <div><a href="<? echo $pages_url_arr[$page_program] ?>"><? echo $pages_arr[$page_program] ?></a></div>
                <div><a href="<? echo $pages_url_arr[$page_archiv] ?>"><? echo $pages_arr[$page_archiv] ?></a></div>
                <div><a href="<? echo $pages_url_arr[$page_mista] ?>"><? echo $pages_arr[$page_mista] ?></a></div>
                <div><a href="<? echo $pages_url_arr[$page_partneri] ?>"><? echo $pages_arr[$page_partneri] ?></a></div>
                <div><a href="<? echo $pages_url_arr[$page_fotogalerie] ?>"><? echo $pages_arr[$page_fotogalerie] ?></a></div>
                <div><a href="<? echo $pages_url_arr[$page_press] ?>"><? echo $pages_arr[$page_press] ?></a></div>
                <div><a href="<? echo $pages_url_arr[$page_kurzy] ?>"><? echo $pages_arr[$page_kurzy] ?></a></div>
            </div>
            <div class="cl"></div>
        </nav>
        
        <div class="mobile-menu"></div>
        
        <div id="search">
            <ul>
                <li><a href="<? echo $page_url_arr['cs'] ?>">Česky</a></li>
                <li><a href="<? echo $page_url_arr['en'] ?>">English</a></li>
                <li><a href="<? echo $page_url_arr['pl'] ?>">Polski</a></li>
            </ul>
        </div>
    </div>
</header>
<!-- ID: <? echo $page_id ?> -->
<!-- TOP: <? echo $page_top ?> -->
<div class="nav-spacer"></div>

<div class="data">
        
    <div class="data-box">

<? 
if ($page == 'homepage') {
?>
        
        <div class="title-big">
            <h1>
                &nbsp; <? echo $logo_title ?> &nbsp;<br/>
                <div></div>
                <span><? echo $logo_date ?></span><br/>
                <a class="button-presale" href="https://www.youtube.com/channel/UCZ3WgPFetSpQZeEazbqpHGg" target="_blank">Online přenosy</a>
            </h1>
        </div>
        
        <div class="title-hp">
            <div class="title-round">
                <a href="<? echo $pages_url_arr[$page_program] ?>"><h2><? echo $pages_arr[$page_program] ?></h2></a>
                <a id="program"></a>
            </div>
<!--             <div class="title-round gray">
                <a href="/archiv"><h2><? echo $pages_arr[$page_archiv] ?></h2></a>
            </div> -->
            <div class="title-round pink">
                <a href="<? echo $pages_url_arr[$page_news] ?>"><h2><? echo $pages_arr[$page_news] ?></h2></a>
            </div>
            <div class="title-round pink" style="position:relative;">
                <a href="https://www.darujme.cz/projekt/1203098" target="_blank">
                    <h2 style="line-height: 1em;
                                position: absolute;
                                top: 50%;
                                left: 50%;
                                transform: translate(-50%,-50%);
                                ">
                        <span style="font-size: .8em;
                                white-space: nowrap;">Podpořte nás</span>
                        <span style="display: block;
                                font-size: .6em;">na Darujme.cz</span>
                    </h2>
                </a>
            </div>
            <br class="cl">
        </div>
        
        <div class="rec-list">
<?
// list next program
$box_counter = 0;
$newArray = array();
//$this_week = date('N')==7 ? date('Y').date('W')+1 : date('Y').date('W');
foreach ($program_arr as $key => $value) {
	
	//if ($box_counter<11 && $this_week<=$program_week_arr[$key]) { // show next X rec. DOCASNE!!!
    //if ($this_week<=$program_year_arr[$key].$program_week_arr[$key]) {
    if($program_dateRegular_arr[$key] >= time()-86400) {
        array_push($newArray, $key);
    }
}
foreach (array_reverse($newArray) as $key) {
    if ($box_counter<12) {
        $box_counter++;
?>
        <a href="<? echo $program_url_arr[$key] ?>" class="rec">
            <div class="img-box"><img src="<? echo $program_pcs_arr[$key] ?>"></div>
            <div class="texts">
                <h3>
                    <? echo $program_date_arr[$key] ?><? echo $program_time_arr[$key] ?><br>
                    <? echo isset($program_idpoi_arr[$key]) && $program_idpoi_arr[$key] ? $pois_arr[$program_idpoi_arr[$key]] : $neurcene_text ?>
                </h3>
                <p>
                    <? echo $program_arr[$key] ?>
                </p>
                <span class="title-round-small"><strong><? echo $vice2_text ?></strong></span>
            </div>
        </a>
<?
    }
}
?>
        </div>
        
<? } else if ($table=='zapoklady' && $page_id==$page_program) { ?>
        
        <div class="title-underline">
            <h2>Kalendář akcí</h2>
        </div>
        
        <div class="rec-list">
<?
// list whole program
$newArray = array();
//$this_week = date('N')==7 ? date('Y').date('W')+1 : date('Y').date('W');
foreach ($program_arr as $key => $value) {
    //if ($this_week<=$program_year_arr[$key].$program_week_arr[$key]) {
    if ($program_dateRegular_arr[$key] >= time()-86400) {
        array_push($newArray, $key);
    }
}
foreach (array_reverse($newArray) as $key) {
?>
    <a href="<? echo $program_url_arr[$key] ?>" class="rec">
        <div class="img-box"><img src="<? echo $program_pcs_arr[$key] ?>"></div>
        <div class="texts">
            <h3>
                <? echo $program_date_arr[$key] ?><? echo $program_time_arr[$key] ?><br>
                <? echo isset($program_idpoi_arr[$key]) && $program_idpoi_arr[$key] ? $pois_arr[$program_idpoi_arr[$key]] : $neurcene_text ?>
            </h3>
            <p>
                <? echo $program_arr[$key] ?>
            </p>
            <span class="title-round-small"><strong><? echo $vice2_text ?></strong></span>
        </div>
    </a>
<?
}
?>
</div>
        
<? } else if ($table=='zapoklady' && $page_id==$page_archiv) { ?>
        
        <div class="title-underline">
            <h2>Archiv</h2>
        </div>
        <div class="submenu">
            <a class="js-date-filter" href="javascript:void(0)" data-year="2020">2020</a>
            <a class="js-date-filter" href="javascript:void(0)" data-year="2019">2019</a>
            <a class="js-date-filter" href="javascript:void(0)" data-year="2018">2018</a>
        </div>
        <div class="rec-list">
<?
// list whole program

//$this_week = date('N')==7 ? date('Y').date('W')+1 : date('Y').date('W');
foreach ($program_arr as $key => $value) {
    //if ($this_week>$program_year_arr[$key].$program_week_arr[$key]) {
    if ($program_dateRegular_arr[$key] < time()-86400) {
?>
        <a href="<? echo $program_url_arr[$key] ?>" class="rec old archiv-item y<? echo $program_year_arr[$key] ?>">
            <div class="img-box"><img src="<? echo $program_pcs_arr[$key] ?>"></div>
            <div class="texts">
                <h3>
                    <? echo $program_date_arr[$key] ?><? echo $program_time_arr[$key] ?><br>
                    <? echo isset($program_idpoi_arr[$key]) && $program_idpoi_arr[$key] ? $pois_arr[$program_idpoi_arr[$key]] : $neurcene_text ?>
                </h3>
                <p>
                    <? echo $program_arr[$key] ?>
                </p>
                <span class="title-round-small"><strong><? echo $vice2_text ?></strong></span>
            </div>
        </a>
<?
    }
}
?>
        </div>
        
<? } else if ($table=='zapoklady' && ($page_id==6 || $page_id==$page_fotogalerie)) { // $page_type==3 

$preview_arr = array();
$sSql = "SELECT * FROM zapokladyobsah WHERE soubor IS NOT NULL AND rozmery IS NOT NULL ORDER BY razeni";
$vysledek = Pg_Exec($sSql);
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
	if (!isset($preview_arr[$zaznam['idzaznamu']])) {
		$preview_arr[$zaznam['idzaznamu']] = printSqlCol('soubor',$zaznam);
	}
}
?>
        
        <div class="title-underline">
            <h2><? echo $title ?></h2>
        </div>
        
        <div class="rec-list">
<?
// list all galleries
foreach ($pages_top_arr as $key => $value) {
	if ($value==$page_fotogalerie || $value==6) {
?>
            <a href="<? echo $pages_url_arr[$key] ?>" class="rec">
                <div class="img-box"><img src="<? echo $root_zp.'galerie/'.$table.'/'.$key.'/'.$preview_arr[$key] ?>"></div>
                <div class="texts">
                    <h3>
                        <? echo $pages_arr[$key] ?>
                    </h3>
                    <p>
                        <? echo utf8_substr_word(strip_tags($pages_text_arr[$key]),150,'') ?>
                    </p>
                    <span class="title-round-small"><strong><? echo $vice2_text ?></strong></span>
                </div>
            </a>
<?
	}
}
?>
        </div>
        
<? } else if ($table=='zapoklady' && $page_id==$page_mista) { ?>
        
        <div class="title-underline">
            <h2><? echo $title ?></h2>
        </div>
        
        <div class="rec-list">
<?
// list all pois by date in program
foreach ($program_arr as $key => $value) {
	$poi_key = isset($program_idpoi_arr[$key]) && $program_idpoi_arr[$key] ? $program_idpoi_arr[$key] : false;
	if ($poi_key>0) {
?>
            <a href="<? echo $pois_url_arr[$poi_key] ?>" class="rec">
                <div class="img-box"><img src="<? echo $pois_soubor_arr[$poi_key] ?>"></div>
                <div class="texts">
                    <h3>
                        <? echo $program_date_arr[$key] ?><br>
                        <? echo isset($program_idpoi_arr[$key]) && $program_idpoi_arr[$key] ? $pois_arr[$program_idpoi_arr[$key]] : $neurcene_text ?>
                    </h3>
                    <p>
                        <? echo utf8_substr_word(strip_tags($pois_text_arr[$poi_key]),150,'') ?>
                    </p>
                    <span class="title-round-small"><strong><? echo $vice2_text ?></strong></span>
                </div>
            </a>
<?
	}
}
?>
        </div>

<? } else if ($table=='poi') { 

// list all pcs inc. video & downloads
$pcs_str = $downloads_str = $first_zoom_str = '';
$first_photo = false;
$sSql = "SELECT * FROM poiobsah WHERE idzaznamu='$page_id' AND soubor IS NOT NULL ORDER BY razeni";
$vysledek = Pg_Exec($sSql);
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
	// video & img
	if (printSqlCol('rozmery',$zaznam)!='') {
		
		// video
		if (printSqlCol('video',$zaznam)) {
			$pcs_str .= '<a href="https://www.youtube.com/embed/'.printSqlCol('video',$zaznam).'?autoplay=1" class="fancybox round-img video fancybox.iframe" rel="group1" title="" style="background-image: url('.$conf_img_path_arr[printSqlCol('imgpath',$zaznam)].'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).')"><img src="'.$root.'images/round.png" alt="'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'" /><span></span></a>';
		
		// pcs
		} else {
			if (!$first_photo) {
				$first_photo = true;
				$first_zoom_str = '<a href="'.$conf_img_path_arr[printSqlCol('imgpath',$zaznam)].'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).'" class="fancybox" rel="group1" title="'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'"></a>';
			} else {
				$pcs_str .= '<a href="'.$conf_img_path_arr[printSqlCol('imgpath',$zaznam)].'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).'" class="fancybox round-img" rel="group1" title="" style="background-image: url('.$conf_img_path_arr[printSqlCol('imgpath',$zaznam)].'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).')"><img src="'.$root.'images/round.png" alt="'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'" /></a>';
			}
		}
	
	} else if (printSqlCol('titulek'.$lang_sql_str,$zaznam)!='') { // downloads
	
		$file_name = printSqlCol('soubor',$zaznam);
		$file_type_arr = explode('.', $file_name);
		$file_type = $file_type_arr[count($file_type_arr)-1];
		$downloads_str .= '<a href="'.$conf_img_path_arr[printSqlCol('imgpath',$zaznam)].'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).'" class="download">'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'</a><br>';
	}
}
?>
        
        <div class="title-underline">
            <h2><? echo $title ?></h2>
        </div>
        
        <div class="text-content">
            <div class="col-2">
                <div class="p20">
                    <? echo $text ?>
                    
<?

$vysledek = Pg_Exec("SELECT * FROM poi WHERE id = '$page_id'");
$zaznam = Pg_Fetch_Array($vysledek,0);
?>
                    <p>
<? if (isset($zaznam['adresa']) && $zaznam['adresa']) { ?>
                        Adresa: <? echo StripSlashes($zaznam['adresa']) ?><br />
<? } ?>
<? if (isset($zaznam['telefon']) && $zaznam['telefon']) { ?>
                        Telefon: <? echo StripSlashes($zaznam['telefon']) ?><br />
<? } ?>
<? if (isset($zaznam['email']) && $zaznam['email']) { ?>
                        E-mail: <a href="mailto:<? echo StripSlashes($zaznam['email']) ?>"><? echo StripSlashes($zaznam['email']) ?></a><br />
<? } ?>
<? if (isset($zaznam['www']) && $zaznam['www']) { ?>
                        <a href="<? if (!preg_match("/http/", $zaznam['www'])) echo 'http://' ?><? echo StripSlashes($zaznam['www']) ?>" onclick="window.open(this.href,'_blank');return false;">odkaz na www</a><br />
<? } ?>
                    </p>
<? 
// print program for poi
foreach ($program_arr as $key => $value) { 
	if (isset($program_idpoi_arr[$key]) && $program_idpoi_arr[$key]==$page_id) {
?>
                    <a href="<? echo $program_url_arr[$key] ?>">
                        <p class="ns">
                            <strong><? echo $udalost_text ?>:<br>
                            <? echo $program_title_arr[$key] ?><br>
                            <? echo $program_date_arr[$key] ?></strong>
                        </p>
                        <span class="title-round-small pos-rel"><strong><? echo $vice2_text ?></strong></span>
                    </a>
                    <br><br>
<? }
} ?>
                </div>
            </div>
            <div class="col-2">
                <div class="pcs-box p20">
                    <? echo $pcs_str.$first_zoom_str ?>
                    <? if ($downloads_str!='') echo '<h3>'.$dokumenty_ke_stazeni_text.'</h3>'.$downloads_str ?>
                </div>
            </div>
            <br class="cl">
        </div>
        
<? if (isset($map) && $map) { ?>
        <div class="title-underline">
            <h2><? echo $mapa_text ?></h2>
        </div>
        
        <div id="map_style"></div>
<? } ?>

<? } else if ($table=='zapoklady' && $page_id==$page_partneri) { // partners ?>
        
        <div class="title-underline">
            <h2><? echo $title ?></h2>
        </div>
        
        <div class="text-content">
<?
$tmp = false;
$sSql = "SELECT * FROM zapokladyobsah WHERE idzaznamu='$page_id' AND soubor IS NOT NULL ORDER BY razeni";
$vysledek = Pg_Exec($sSql);
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
	if (!$tmp) {
		$tmp = printSqlCol('titulek'.$lang_sql_str,$zaznam);
?>
            <div class="col-3 col-partners">
                <div class="title-underline2">
                    <h3><? echo $tmp ?></h3>
                </div>
            </div>
            <div class="col-2-3">
<?
	} else if ($tmp!=printSqlCol('titulek'.$lang_sql_str,$zaznam)) {
		$tmp = printSqlCol('titulek'.$lang_sql_str,$zaznam);
?>
                 <br class="cl">
            </div>
            <div class="col-3">
                <div class="title-underline2">
                    <h3><? echo $tmp ?></h3>
                </div>
            </div>
            <div class="col-2-3">
<?
	}
?>
            <a href="<? if (strpos(printSqlCol('video',$zaznam), 'http')!==false) {}else{ echo 'http://'; } ?><? echo printSqlCol('video',$zaznam) ?>" target="_blank" class="partner"><img src="<? //echo $root ?>http://www.zapoklady.cz/galerie/zapoklady/<? echo $page_id ?>/<? echo printSqlCol('soubor',$zaznam) ?>" alt="<? echo strip_tags(printSqlCol('popis'.$lang_sql_str,$zaznam)) ?>"></a>
<? } ?>
                 <br class="cl">
            </div>
            
            <br class="cl">
            
            <div class="col-3">
                <div class="title-underline2 to-top">
                    <h3><? echo $perex ?></h3>
                </div>
            </div>
            <div class="col-2-3">
                <? echo $text ?>
            </div>
            
            <br class="cl">
        </div>

<? } else if ($table=='aktuality' && in_array($page_id,$program_key_arr)) { // program detail // type==10

// detect program detail


// list all pcs inc. video & downloads
$pcs_str = $downloads_str = '';
$sSql = "SELECT * FROM aktualityobsah WHERE idzaznamu='$page_id' AND soubor IS NOT NULL ORDER BY razeni";
$vysledek = Pg_Exec($sSql);
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
	
	// downloads
	if (printSqlCol('rozmery',$zaznam)!='') {
		
		// video
		if (printSqlCol('video',$zaznam)) {
			$pcs_str .= '<a href="https://www.youtube.com/embed/'.printSqlCol('video',$zaznam).'?autoplay=1" class="fancybox round-img video fancybox.iframe" rel="group1" title="" style="background-image: url('.$conf_img_path_arr[printSqlCol('imgpath',$zaznam)].'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).')"><img src="'.$root.'images/round.png" alt="'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'" /><span></span></a>';
		
		// pcs
		} else {
			$pcs_str .= '<a href="'.$conf_img_path_arr[printSqlCol('imgpath',$zaznam)].'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).'" class="fancybox round-img" rel="group1" title="" style="background-image: url('.$conf_img_path_arr[printSqlCol('imgpath',$zaznam)].'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).')"><img src="'.$root.'images/round.png" alt="'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'" /></a>';
		}
	
	} else if (printSqlCol('titulek'.$lang_sql_str,$zaznam)!='') { // downloads
	
		$file_name = printSqlCol('soubor',$zaznam);
		$file_type_arr = explode('.', $file_name);
		$file_type = $file_type_arr[count($file_type_arr)-1];
		$downloads_str .= '<a href="'.$conf_img_path_arr[printSqlCol('imgpath',$zaznam)].'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).'" class="download">'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'</a><br>';
	}
}
?>
        
        <div class="title-underline">
            <h2><? echo $title ?></h2>
        </div>
        
        <div class="text-content">
            <div class="col-2">
                <div class="p20">
                    <h2 class="title-text">
                        <!-- <? echo $table ?> -->
                        <span><? echo $program_day_arr[$page_id] ?> <? echo $program_date_arr[$page_id] ?><? echo $program_time_arr[$page_id] ?><br />
                        <? echo isset($program_idpoi_arr[$page_id]) && $program_idpoi_arr[$page_id] ? $pois_arr[$program_idpoi_arr[$page_id]] : $neurcene_text ?></span>
                        <? if (!empty($program_www_arr[$page_id]) && preg_match('/youtu/',$program_www_arr[$page_id]) ) { ?>
                            <a class="button-presale button-presale--pink" href="<? echo $program_www_arr[$page_id] ?>" target="_blank">Online vysílání</a>
                        <? } ?>
                    </h2>
                    <? echo $text ?>
<? 
// print program for poi
foreach ($program_arr as $key => $value) { 
	if (isset($program_idpoi_arr[$key]) && $program_idpoi_arr[$key] && $key==$page_id) {
		$poi_id = $program_idpoi_arr[$key];
?>
                    <? if (!empty($program_www_arr[$key]) && !preg_match('/youtu/',$program_www_arr[$key])) { ?><p><a class="button-presale" href="<? echo $program_www_arr[$key] ?>" target="_blank"><? echo $presale_text ?></a><br><br></p><? } ?>
                    <a href="<? echo $pois_url_arr[$poi_id] ?>">
                        <p class="ns">
                            <strong><? echo $misto_akce_text ?>:<br>
                            <? echo $pois_arr[$poi_id] ?></strong>
                        </p>
                        <span class="title-round-small pos-rel"><strong><? echo $vice2_text ?></strong></span>
                    </a>
<? }
} ?>
                </div>
            </div>
            <div class="col-2">
                <div class="pcs-box p20">
                    <? echo $pcs_str ?>
                    <? if ($downloads_str!='') echo '<h3>'.$dokumenty_ke_stazeni_text.'</h3>'.$downloads_str ?>
                </div>
            </div>
            <br class="cl">
        </div>
        
<? if (isset($map) && $map) { ?>
        <div class="title-underline">
            <h2><? echo $mapa_text ?></h2>
        </div>
        
        <div id="map_style"></div>
<? } ?>

<? } else if ($table=='zapoklady' && $page_id==$page_news) { ?>
        
        <div class="title-underline">
            <h2><? echo $title ?></h2>
        </div>
        
        <div class="rec-list">

<? foreach ($pages_top_arr as $key => $value) {
	if ($value==$page_news) {
?>
            <a href="<? echo $pages_url_arr[$key] ?>" class="rec">
                <div class="texts">
                    <h3>
                        <? echo $pages_arr[$key] ?>
                    </h3>
                    <p>
                        <? echo utf8_substr_word(strip_tags($pages_text_arr[$key]),150,'') ?>
                    </p>
                    <span class="title-round-small"><strong><? echo $vice2_text ?></strong></span>
                </div>
            </a>
<? }
} ?>
            <br class="cl">
        </div>

<? } else if ($table=='zapoklady' && $page_top==$page_news && 1>1) { // detail page, type==10 ?>
        <div class="title-underline">
            <h2><? echo $title ?></h2>
        </div>
        
        <div class="text-content">
            <div class="col-2">
                <div class="p20">
                    <? echo $text ?>
                    <? if ($downloads_str!='') echo '<h3>'.$dokumenty_ke_stazeni_text.'</h3>'.$downloads_str ?>
                </div>
            </div>
            <div class="col-2">
                <div class="pcs-box p20">
                    <? echo $pcs_str ?>
                </div>
            </div>
            <br class="cl">
        </div>

<? } else if ($table=='zapoklady' && $page_id==$page_press) { ?>
        <div class="title-underline">
            <h2><? echo $title ?></h2>
        </div>
        
        <div class="text-content">
            <div class="col">
                <div class="p20 center">
                    <? echo $text ?>
<?
// list all public download files from program order by last edit
$download_arr = array();
$sSql = "SELECT * FROM zapoklady WHERE idhlavnistranky='$page_id' AND status>'0' ORDER BY razeni ASC"; //datumzmeny
$press = Pg_Exec($sSql);
/*
while ($zaznam = Pg_Fetch_Assoc($press)) {
    echo $zaznam['id'];
    $sSql = "SELECT * FROM zapokladyobsah WHERE idzaznamu='".$zaznam['id']."' AND soubor IS NOT NULL ORDER BY razeni";

     $pressID = printSqlCol('id',$zaznam['id']);
    $sSql = "SELECT * FROM zapokladyobsah WHERE idzaznamu='$pressID' AND soubor IS NOT NULL ORDER BY razeni";

    $vysledek = Pg_Exec($sSql);
}
*/
while ($zaznam = Pg_Fetch_Assoc($press)) {


	$sSql = "SELECT * FROM zapokladyobsah WHERE idzaznamu='".$zaznam['id']."' AND soubor IS NOT NULL ORDER BY razeni ASC";
	$vysledek = Pg_Exec($sSql);
	$pocetzaznamu = pg_num_rows($vysledek);
	if ($pocetzaznamu>0) {

        while ($zaznam2 = Pg_Fetch_Assoc($vysledek)) {
            $download_arr[$zaznam2['id']] = $root_zp . 'galerie/' . $table . '/' . $zaznam['id'] . '/' . printSqlCol('soubor', $zaznam2);
            //$download_idzaznamu_arr[$zaznam2['id']] = printSqlCol('idzaznamu',$zaznam2);
            $download_title_arr[$zaznam2['id']] = printSqlCol('titulek'.$lang_sql_str,$zaznam2);
            $download_text_arr[$zaznam2['id']] = printSqlCol('popis'.$lang_sql_str,$zaznam2);

        }

    }
}

foreach ($download_arr as $key => $value) {
	$idz = @$download_idzaznamu_arr[$key];
?>
                    <p>
                        <a href="<? echo $download_arr[$key] ?>" class="download" target="_blank">
                            <strong>
                                <? echo $download_title_arr[$key] ?>
                            </strong>
                        </a>
<? if ($idz) { ?>
                        <br>
                        <!--<? echo $program_arr[$idz] ?> / --><? echo $program_date_arr[$idz] ?> - <a href="<? echo $program_url_arr[$idz] ?>" class="sml"><? echo $vice2_text ?></a>
<? } ?>
<? if (isset($download_text_arr[$key])) { ?>
                        <br><br>
                        <? echo $download_text_arr[$key] ?>
<? } ?>
                    </p>
<? } ?>
                </div>
            </div>
        </div>

<? } else { // other pages
// photogallery
if ($page_type==3) {
?>

        <div class="title-underline">
            <h2><? echo $title ?></h2>
        </div>
        
        <div class="text-content">
            <div class="col">
                <div class="p20">
                    <? echo $text ?>
                </div>
            </div>
<?
	// list all pcs inc. video & downloads
	$pcs_str = $downloads_str = '';
	$sSql = "SELECT * FROM zapokladyobsah WHERE idzaznamu='$page_id' AND soubor IS NOT NULL ORDER BY razeni";
	$vysledek = Pg_Exec($sSql);
	$pocetzaznamu = pg_num_rows($vysledek);
	if ($pocetzaznamu>0) {
?>
            <div class="gallery">

<?
	while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
		
		// downloads
		if (printSqlCol('rozmery',$zaznam)!='') {
			
			// video
			if (printSqlCol('video',$zaznam)) {
				$pcs_str .= '<a href="https://www.youtube.com/embed/'.printSqlCol('video',$zaznam).'?autoplay=1" class="fancybox pcs-detail video fancybox.iframe" rel="group1" style="background-image: url('.$root_zp.'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).')" title="'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'"><img src="'.$root.'images/gallery.png" alt="'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'" /><span></span></a>';
			
			// pcs
			} else {
				$pcs_str .= '<a href="'.$root_zp.'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).'" class="fancybox pcs-detail" rel="group1" style="background-image: url('.$root_zp.'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).')" title="'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'"><img src="'.$root.'images/gallery.png" alt="'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'" /></a>';
			}
		
		}
?>
                
<? } ?>
                <? echo $pcs_str ?>
            </div>
<?
}

// images with comments: zastita, historie?
} else if ($page_type==2) {
?>

        <div class="title-underline">
            <h2><? echo $title ?></h2>
        </div>
        
        <div class="text-content">
            <div class="col">
                <div class="p20">
                    <? echo $text ?>
                </div>
            </div>
<?
	// list all pcs inc. video & downloads
	$pcs_str = $downloads_str = '';
	$sSql = "SELECT * FROM zapokladyobsah WHERE idzaznamu='$page_id' AND soubor IS NOT NULL ORDER BY razeni";
	$vysledek = Pg_Exec($sSql);
	$pocetzaznamu = pg_num_rows($vysledek);
	if ($pocetzaznamu>0) {
?>
            <div class="subpage-list">
<?
	while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
		
		// downloads
		if (printSqlCol('rozmery',$zaznam)!='') {
			
			// video
			if (printSqlCol('video',$zaznam)) {
				$pcs_str .= '<a href="https://www.youtube.com/embed/'.printSqlCol('video',$zaznam).'?autoplay=1" class="fancybox round-img video fancybox.iframe" rel="group1" title="" style="background-image: url('.$root_zp.'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).')"><img src="'.$root.'images/round.png" alt="'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'" /><span></span></a>';
			
			// pcs
			} else {
?>
                <div class="col-4 subpage">
                    <div class="p20 center">
                        <a href="<? echo $root_zp.'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam) ?>" class="fancybox round-img" rel="group1" style="background-image: url('<? echo $root_zp.'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam) ?>')"><img src="<? echo $root ?>images/round.png" alt="<? echo printSqlCol('titulek'.$lang_sql_str,$zaznam) ?>"></a>
                        <h3><? echo printSqlCol('titulek'.$lang_sql_str,$zaznam) ?></h3>
                        <p><? echo printSqlCol('popis'.$lang_sql_str,$zaznam) ?></p>
                    </div>
                </div>
<?
			}
		
		} else if (printSqlCol('titulek'.$lang_sql_str,$zaznam)!='') { // downloads
		
			$file_name = printSqlCol('soubor',$zaznam);
			$file_type_arr = explode('.', $file_name);
			$file_type = $file_type_arr[count($file_type_arr)-1];
			$downloads_str .= '<a href="'.$root_zp.'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).'" class="download">'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'</a><br>';
		}
	}
?>
                <br class="cl">
            </div>
<? } ?>
<? if ($downloads_str!='') { ?>
            <div class="col">
                <div class="pcs-box p20">
                    <? echo $pcs_str ?>
                    <h3><? echo $dokumenty_ke_stazeni_text ?></h3>
                    <? echo $downloads_str ?>
                </div>
            </div>
            <br class="cl">
<? } ?>
        </div>
        
<?
// common page with photogallery, downloads
} else {

	// list all pcs inc. video & downloads
	$pcs_str = $downloads_str = '';
	$sSql = "SELECT * FROM zapokladyobsah WHERE idzaznamu='$page_id' AND soubor IS NOT NULL ORDER BY razeni";
	$vysledek = Pg_Exec($sSql);
	while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
		
		// downloads
		if (printSqlCol('rozmery',$zaznam)!='') {
			
			// video
			if (printSqlCol('video',$zaznam)) {
				$pcs_str .= '<a href="https://www.youtube.com/embed/'.printSqlCol('video',$zaznam).'?autoplay=1" class="fancybox round-img video fancybox.iframe" rel="group1" title="" style="background-image: url('.$root_zp.'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).')"><img src="'.$root.'images/round.png" alt="'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'" /><span></span></a>';
			
			// pcs
			} else {
				$pcs_str .= '<a href="'.$root_zp.'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).'" class="fancybox round-img" rel="group1" title="" style="background-image: url('.$root_zp.'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).')"><img src="'.$root.'images/round.png" alt="'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'" /></a>';
			}
		
		} else if (printSqlCol('titulek'.$lang_sql_str,$zaznam)!='') { // downloads
		
			$file_name = printSqlCol('soubor',$zaznam);
			$file_type_arr = explode('.', $file_name);
			$file_type = $file_type_arr[count($file_type_arr)-1];
			$downloads_str .= '<a href="'.$root_zp.'galerie/'.$table.'/'.$page_id.'/'.printSqlCol('soubor',$zaznam).'" class="download">'.printSqlCol('titulek'.$lang_sql_str,$zaznam).'</a><br>';
		}
	}
?>
        <div class="title-underline">
            <h2><? echo $title ?></h2>
        </div>
        
        <div class="text-content">
<? if ($page_id == $page_o_festivalu && in_array($page_o_festivalu,$pages_top_arr)) { ?>
                    <div class="submenu">
<? foreach ($pages_top_arr as $key => $value) {
	if ($value==$page_o_festivalu) {
?>
                        <a href="<? echo $pages_url_arr[$key] ?>"><? echo $pages_arr[$key] ?></a>
<? }
} ?>
                    </div>
<? } ?>
            <div class="col-2">
                <div class="p20">
                    <? echo $text ?>
                </div>
            </div>
            <div class="col-2">
                <div class="pcs-box p20">
                    <? echo $pcs_str ?>
                    <? if ($downloads_str!='') echo '<h3>'.$dokumenty_ke_stazeni_text.'</h3>'.$downloads_str ?>
                </div>
            </div>
            <br class="cl">
        </div>

<? } // end common page ?>
        
<? if (isset($map) && $map) { ?>
        <div class="title-underline">
            <h2><? echo $mapa_text ?></h2>
        </div>
        
        <div id="map_style"></div>
<? } ?>

<? } ?>
        
        <br class="cl">
        
        <div class="texts-wide partners">
            <br class="cl">
            
            <div class="title-underline">
                <h2><? echo $partneri_text ?></h2>
            </div>
            
<?
if ($table == "aktuality") {
    $sSql = "SELECT * FROM zapokladyobsah WHERE idzaznamu='$page_partneri' AND rozmery IS NOT NULL ORDER BY razeni LIMIT 4";
} else {
    $sSql = "SELECT * FROM zapokladyobsah WHERE idzaznamu='$page_partneri' AND rozmery IS NOT NULL ORDER BY razeni LIMIT 5";
}
$vysledek = Pg_Exec($sSql);
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
?>
            <a href="<? if (strpos(printSqlCol('video',$zaznam), 'http')!==false) {}else{ echo 'http://'; } ?><? echo printSqlCol('video',$zaznam) ?>" target="_blank"><img src="http://www.zapoklady.cz/galerie/zapoklady/<? echo $page_partneri ?>/<? echo $zaznam['soubor'] ?>" alt="<? strip_tags(printSqlCol('popis'.$lang_sql_str,$zaznam)) ?>"></a>
<?
}
?>
            <br class="cl">
            
            <p><a href="<? echo $pages_url_arr[$page_partneri] ?>"><? echo $vsichni_partneri_text ?></a></p>
            
        </div>
        
        <br class="cl">
        
        <div class="texts-wide bg-field">
            <br class="cl">
        
            <div class="title-underline">
                <h2><? echo $dalsi_akce_text ?></h2>
            </div>
            
            <div class="rec-4 news">
<?
// print banners & news
$box_counter = 0;
$news_datum = date('Y-m-d'); // (5.4.) 10.4. (20.5.)
$sSql = "SELECT * FROM aktuality WHERE status>'0' AND zapoklady IS TRUE AND datum>='$news_datum' AND typ!='10' ORDER BY datum LIMIT 4";
$vysledek = Pg_Exec($sSql);
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
	$cas = printSqlCol('cas',$zaznam) ? ' / '.$od_text.' '.GetCzTime(printSqlCol('cas',$zaznam)) : '';
?>
                <a href="<? echo $vkcb_link.$language_link.printSqlCol('link'.$lang_sql_str,$zaznam) ?>" target="_blank">
                    <p>
                        <strong><? echo GetCzDateShortFree(printSqlCol('datum',$zaznam)) ?><? echo $cas ?><br>
                        <? echo printSqlCol('titulek'.$lang_sql_str,$zaznam) ?></strong>
                        <br>
                        <? echo utf8_substr_word(strip_tags(printSqlCol('popis'.$lang_sql_str,$zaznam)),50,'') ?>
                    </p>
                </a>
<?
}
?>
                <br class="cl">
            </div>
            
        </div>
        
    </div>
</div>

<footer>
    <div class="footer-box">
                
        <div class="copy">
            <p>
                Veškerá práva vyhrazena <? echo date('Y') ?> Za poklady Broumovska o.p. 
            </p>
            <p>
                <a onclick="window.open(this.href,'_blank');return false;" href="http://www.hmsdesign.cz" title="Design, koncepce, výroba HMS design / HMS webdesign">Design, koncepce, výroba HMS design / HMS webdesign</a>
            </p>
        </div>
    
    </div>
</footer>

<div class="menu-right">
    <a onclick="window.open(this.href,'_blank');return false;" href="https://www.facebook.com/zapokladybroumovska/" class="facebook"></a>
    <a onclick="window.open(this.href,'_blank');return false;" href="https://www.darujme.cz/projekt/1203098" class="gift"><span>Podpořte<br>nás</span></a>
</div>

<script type="text/javascript"> 
  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-24008468-8']);
  _gaq.push(['_trackPageview']); (function() {
    var ga = document.createElement('script');
    ga.type = 'text/javascript';
    ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0];
    s.parentNode.insertBefore(ga, s);  
  })();
</script>
<script type="text/javascript">
	/* <![CDATA[ */
	var seznam_retargeting_id = 74394;
	/* ]]> */
</script>
<script type="text/javascript" src="//c.imedia.cz/js/retargeting.js"></script>
</body>
</html>